--------------------------------------------------------
--  DDL for Table SYS_USER_LOGON_AUDIT
--------------------------------------------------------
  CREATE TABLE "ACCOUNT_LOGON_AUDIT" 
   (	
      "APPLICATION_KEY" VARCHAR2(36 BYTE), 
      "ID" NUMBER, 
      "CLIENT_USER_NAME" VARCHAR2(50 BYTE), 
      "CLIENT_MACHINE_NAME" VARCHAR2(128 BYTE), 
      "CLIENT_IP_ADDRESS" VARCHAR2(11 BYTE), 
      "USER_NAME" VARCHAR2(20 BYTE), 
      "FULLNAME_ENGLISH" VARCHAR2(128 BYTE), 
      "CREATION_DATE" DATE
   );
   
--------------------------------------------------------
--  DDL for Index SYS_USER_LOGON_AUDIT_PK
--------------------------------------------------------
  CREATE UNIQUE INDEX "ACCOUNT_LOGON_AUDIT_PK" ON "SYS_USER_LOGON_AUDIT" ("ID", "USER_NAME") ;
  
--------------------------------------------------------
--  Constraints for Table SYS_USER_LOGON_AUDIT
--------------------------------------------------------
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" ADD CONSTRAINT "ACCOUNT_LOGON_AUDIT_PK" PRIMARY KEY ("APPLICATION_KEY", "ID", "USER_NAME") ;
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CREATION_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("FULLNAME_ENGLISH" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CLIENT_IP_ADDRESS" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CLIENT_MACHINE_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CLIENT_USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("ID" NOT NULL ENABLE);
